StudentTransferCredit 
EntityType  Independent 
Logical Entity Name  StudentTransferCredit 
Default Table Name  AmCollegeTransfer 
Logical Only  NO 
Owner  dbo 
Definition 
 
Note 
 

StudentTransferCredit Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
StudentTransferCreditId(PK)    INTEGER  NO 
 
CollegeId(FK)    INTEGER  YES 
 
CollegeName    VARCHAR(60)  YES 
 
CollegeCourseCode    VARCHAR(16)  YES 
 
CollegeCourseDescription    VARCHAR(75)  YES 
 
CollegeCourseCredits    NUMERIC(7, 2)  YES 
 
CollegeCourseCompletedDate    DATETIME  NO 
 
StudentId(FK)    INTEGER  NO 
 
CollegeCourseId(FK)    INTEGER  YES 
 
CreatedDateTime    DATETIME  NO 
 
LastModifiedDateTime    DATETIME  NO 
 
LastModifiedUserId(FK)    INTEGER  NO 
 
RowVersion    TIMESTAMP/DATE  NO 
 
Note    VARCHAR(3000)  YES 
 
LetterGrade    CHAR(8)  YES 
 
TransferCreditStatusId(FK)    INTEGER  NO 
 
CreditHoursEarned    NUMERIC(7, 2)  NO 
 
CourseId(FK)    INTEGER  YES 
 
CollegeCourseLetterGrade    CHAR(3)  YES 
 
ApprovedDate    DATETIME  YES 
 
TermId(FK)    INTEGER  YES 
 
CollegeCourseCreditHoursAttempted    NUMERIC(9, 2)  YES 
 
CollegeCourseClockHoursAttempted    NUMERIC(9, 2)  YES 
 
CollegeCourseGradePoints    NUMERIC(9, 2)  YES 
 
CollegeCourseCreditHoursEarned    NUMERIC(9, 2)  YES 
 
CollegeCourseClockHoursEarned    NUMERIC(9, 2)  YES 
 
CollegeCourseStartDate    DATETIME  YES 
 
ClockHours    NUMERIC(9, 2)  YES 
 
ClockHoursEarned    NUMERIC(9, 2)  YES 
 
HighSchoolId(FK)    INTEGER  YES 
 
HighSchoolCourseId(FK)    INTEGER  YES 
 
TransferCreditTypeId(FK)    INTEGER  YES 
 
HighSchoolId(FK)    INTEGER  YES 
 
StudentId(FK)    INTEGER  YES 
 

StudentTransferCredit Keys 
Key Name  Key Type  Keys 
Nk_AmCollegeTransferAmTransferTypeID  Inversion Entry  TransferCreditTypeId 
Nk_AmCollegeTransferAmHighSchoolCourseID  Inversion Entry  HighSchoolCourseId 
AmCollegeTransfer_UserID_N_N_IDX  Inversion Entry  LastModifiedUserId 
AmCollegeTransfer_AmCollegeCourseID_N_N_IDX  Inversion Entry  CollegeCourseId 
AmCollegeTransfer_AmCollegeID_N_N_IDX  Inversion Entry  CollegeId 
AmCollegeTransfer_AdCourseID_N_N_IDX  Inversion Entry  CourseId 
Nk_AmCollegeTransferCompletionDateStartDate  Inversion Entry  CollegeCourseCompletedDate, CollegeCourseStartDate 
AmCollegeTransfer_AmCollegeTransferStatusID_N_N_IDX  Inversion Entry  TransferCreditStatusId 
AmCollegeTransfer_AdTermID_N_N_IDX  Inversion Entry  TermId 
Nk_AmCollegeTransferAmHighSchoolID  Inversion Entry  HighSchoolId 
AmCollegeTransfer_SyStudentID_N_N_IDX  Inversion Entry  StudentId 
AmCollegeTransfer_AmCollegeTransferID_U_C_IDX  PrimaryKey  StudentTransferCreditId 

StudentTransferCredit Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
College  Non-Identifying  Zero or One to Zero or More        CollegeId  NO 
CollegeCourse  Non-Identifying  Zero or One to Zero or More        CollegeCourseId  NO 
Course  Non-Identifying  Zero or One to Zero or More        CourseId  NO 
Term  Non-Identifying  Zero or One to Zero or More        TermId  NO 
College  Non-Identifying  Zero or One to Zero or More        CollegeId  NO 
Student  Non-Identifying  One To Zero or More        StudentId  NO 
Staff  Non-Identifying  One To Zero or More        LastModifiedUserId  NO 
Course  Non-Identifying  Zero or One to Zero or More        CourseId  NO 
CollegeCourse  Non-Identifying  Zero or One to Zero or More        CollegeCourseId  NO 
TransferCreditStatus  Non-Identifying  One To Zero or More        TransferCreditStatusId  NO 
HighSchoolCourse  Non-Identifying  Zero or One to Zero or More        HighSchoolCourseId  NO 
HighSchool  Non-Identifying  Zero or One to Zero or More        HighSchoolId  NO 
TransferCreditType  Non-Identifying  Zero or One to Zero or More        TransferCreditTypeId  NO 
HighSchool  Non-Identifying  Zero or One to Zero or More        HighSchoolId  NO 
HighSchoolCourse  Non-Identifying  Zero or One to Zero or More        HighSchoolCourseId  NO 
Student  Non-Identifying  Zero or One to Zero or More        StudentId  NO 
Term  Non-Identifying  Zero or One to Zero or More        TermId  NO 
TransferCreditStatus  Non-Identifying  Zero or One to Zero or More        TransferCreditStatusId  NO 
TransferCreditType  Non-Identifying  Zero or One to Zero or More        TransferCreditTypeId  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 
StudentCourse  Non-Identifying  One To Zero or More          NO 
StudentGpaIncludedCourse  Non-Identifying  One To Zero or More          NO 
AmCollegeTransferExternalCourse  Non-Identifying  One To Zero or More          NO 
AmCollegeTransferInternalCourse  Non-Identifying  One To Zero or More          NO 

StudentTransferCredit Check Constraints 
Check Constraint Name  CheckConstraint 

StudentTransferCredit Where Used - Model Usage 
Mapped Object  Is User Defined?  Denormalization Mappings  Description  Bound Attachments 
Logical
dbo.StudentTransferCredit 
NO       
Physical (Microsoft SQL Server)
dbo.AmCollegeTransfer 
NO       

StudentTransferCredit Where Used - Submodel Usage 
Model  Submodel Usage 
Logical  Main Model 
Logical  PreviousEd_TransferCredits 
Physical (Microsoft SQL Server)  Main Model 
Physical (Microsoft SQL Server)  Academic Records 
Physical (Microsoft SQL Server)  Admissions 

StudentTransferCredit Data Movement Rules 
Name  Type  Rule Text/Value